Атом - техцентр авто

MySQL статистика (25)

Query	Rows	Time	Cached
SELECT items.id, items.parent_id, items.title, items.is_hidden_in_menu, items.sort_order, items.href, menus.code as menu_code, menus.use_code_in_links as menu_code_in_links, blocks.id as block_id, blocks.code as block_code, blocks.description, blocks.content, blocks.template, blocks.block_type, f.id as image_id, f.disk_name as image_path FROM admin_menu_items as items LEFT JOIN admin_menus as menus ON menus.id = items.menu_id LEFT JOIN admin_text_blocks as blocks ON blocks.id = items.text_block_id LEFT JOIN db_files as f ON f.master_object_id = items.id AND f.master_object_class = 'Admin_MenuItem' AND f.field = 'image' WHERE items.is_hidden is null ORDER BY items.parent_id, items.sort_order	34	0.002163	false
select count(*) from ( (select id as object_id, 'News_Post' as object_name, publish_date as sdate from news_posts where (title like '%оценка%') OR (description like '%оценка%') OR (content like '%оценка%') OR (title like '%кузовного%') OR (description like '%кузовного%') OR (content like '%кузовного%') OR (title like '%ремонта%') OR (description like '%ремонта%') OR (content like '%ремонта%') OR (title like '%по%') OR (description like '%по%') OR (content like '%по%') OR (title like '%фото%') OR (description like '%фото%') OR (content like '%фото%') order by publish_date desc) UNION (select id as object_id, 'Admin_TextBlock' as object_name, updated_at as sdate from admin_text_blocks where (admin_text_blocks.code like '/%') AND ((title like '%оценка%') OR (content like '%оценка%') OR (description like '%оценка%') OR (title like '%кузовного%') OR (content like '%кузовного%') OR (description like '%кузовного%') OR (title like '%ремонта%') OR (content like '%ремонта%') OR (description like '%ремонта%') OR (title like '%по%') OR (content like '%по%') OR (description like '%по%') OR (title like '%фото%') OR (content like '%фото%') OR (description like '%фото%'))) ) as hell_s_partition	1	0.001654	false
(select id as object_id, 'News_Post' as object_name, publish_date as sdate from news_posts where (title like '%оценка%') OR (description like '%оценка%') OR (content like '%оценка%') OR (title like '%кузовного%') OR (description like '%кузовного%') OR (content like '%кузовного%') OR (title like '%ремонта%') OR (description like '%ремонта%') OR (content like '%ремонта%') OR (title like '%по%') OR (description like '%по%') OR (content like '%по%') OR (title like '%фото%') OR (description like '%фото%') OR (content like '%фото%') order by publish_date desc) UNION (select id as object_id, 'Admin_TextBlock' as object_name, updated_at as sdate from admin_text_blocks where (admin_text_blocks.code like '/%') AND ((title like '%оценка%') OR (content like '%оценка%') OR (description like '%оценка%') OR (title like '%кузовного%') OR (content like '%кузовного%') OR (description like '%кузовного%') OR (title like '%ремонта%') OR (content like '%ремонта%') OR (description like '%ремонта%') OR (title like '%по%') OR (content like '%по%') OR (description like '%по%') OR (title like '%фото%') OR (content like '%фото%') OR (description like '%фото%'))) order by sdate desc limit 0, 20	9	0.001225	false
SELECT seo_settings.* FROM seo_settings ORDER BY id desc LIMIT 0, 1	1	0.000367	false
update seo_settings set individual_seo_settings = 'a:0:{}'	-	0.000132	false
SELECT (menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.* FROM admin_text_blocks LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id WHERE (admin_text_blocks.id = '23') LIMIT 0, 1	1	0.000404	false
SELECT (menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.* FROM admin_text_blocks LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id WHERE (admin_text_blocks.id = '26') LIMIT 0, 1	1	0.000339	false
SELECT (menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.* FROM admin_text_blocks LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id WHERE (admin_text_blocks.id = '24') LIMIT 0, 1	1	0.000354	false
SELECT (menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.* FROM admin_text_blocks LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id WHERE (admin_text_blocks.id = '33') LIMIT 0, 1	1	0.000275	false
SELECT (menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.* FROM admin_text_blocks LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id WHERE (admin_text_blocks.id = '27') LIMIT 0, 1	1	0.000257	false
SELECT (menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.* FROM admin_text_blocks LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id WHERE (admin_text_blocks.id = '25') LIMIT 0, 1	1	0.000231	false
SELECT (news_categories.code) as category_code, (select group_concat(news_posts_versions.created_at ORDER BY 1 SEPARATOR ', ') from news_posts_versions where news_posts_versions.post_id = news_posts.id) as versions_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = news_posts.id and (master_object_class='News_Post' and field='photos')) as photos_calculated, news_posts.* FROM news_posts LEFT JOIN news_categories ON news_categories.id=news_posts.category_id WHERE (news_posts.id = '3') LIMIT 0, 1	1	0.000817	false
SELECT (news_categories.code) as category_code, (select group_concat(news_posts_versions.created_at ORDER BY 1 SEPARATOR ', ') from news_posts_versions where news_posts_versions.post_id = news_posts.id) as versions_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = news_posts.id and (master_object_class='News_Post' and field='photos')) as photos_calculated, news_posts.* FROM news_posts LEFT JOIN news_categories ON news_categories.id=news_posts.category_id WHERE (news_posts.id = '2') LIMIT 0, 1	1	0.000381	false
SELECT (menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.* FROM admin_text_blocks LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id WHERE (admin_text_blocks.id = '20') LIMIT 0, 1	1	0.000232	false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='icon')) as icon_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.text_block_id = '23') LIMIT 0, 1	1	0.000492	false
SELECT admin_menu_items.* FROM admin_menu_items ORDER BY sort_order	34	0.000389	false
SELECT admin_menus.* FROM admin_menus WHERE (admin_menus.id = '4') LIMIT 0, 1	1	0.000180	false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='icon')) as icon_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.text_block_id = '26') LIMIT 0, 1	1	0.000422	false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='icon')) as icon_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.text_block_id = '24') LIMIT 0, 1	1	0.000337	false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='icon')) as icon_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.text_block_id = '33') LIMIT 0, 1	1	0.000351	false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='icon')) as icon_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.text_block_id = '27') LIMIT 0, 1	1	0.000366	false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='icon')) as icon_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.text_block_id = '25') LIMIT 0, 1	1	0.000371	false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='icon')) as icon_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.text_block_id = '20') LIMIT 0, 1	1	0.000364	false
SELECT admin_menus.* FROM admin_menus WHERE (admin_menus.id = '1') LIMIT 0, 1	1	0.000144	false
SELECT admin_module_settings.* FROM admin_module_settings WHERE (admin_module_settings.module_id='admin') AND (admin_module_settings.form_id='default') LIMIT 0, 1	1	0.000450	false

Оставить заявку